UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rD9hKCdbrQHcBRP63bT38YnEVfp0pFSSP1GGVbsQs28='
WHERE
key_id = 'db76d1559f125157594541c0ae32d8632a707e144cc6caa811b8aa81e5a735d6'
AND (
token = 'rD9hKCdbrQHcBRP63bT38YnEVfp0pFSSP1GGVbsQs28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)