UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bNtXuYhV2rUS456ydtTMBcFPD+gpXhJnykA2kIeNZBQ='
WHERE
key_id = '1486f6aa698bbcc4901f4ce1bb84b061a02df549521956d7e6320519063ae865'
AND (
token = 'bNtXuYhV2rUS456ydtTMBcFPD+gpXhJnykA2kIeNZBQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)