UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tkKw/xKitTSh4OpKsl8HDoOHVB8CIUN8mavFltuYijY='
WHERE
key_id = 'c7ce0f5c3248aac899ba5cab023bd85a4d186bcae2f675d5e9d7455e697c1731'
AND (
token = 'tkKw/xKitTSh4OpKsl8HDoOHVB8CIUN8mavFltuYijY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)