UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YFsADsP7PBxiOrApgPjWc+PqZRJnsP7dPKZPpDBRmgg='
WHERE
key_id = '8c63906b050d90055a9ff88232fa62f17a992d5b852daead8a575cb04e84ad3e'
AND (
token = 'YFsADsP7PBxiOrApgPjWc+PqZRJnsP7dPKZPpDBRmgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)