UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VTtDLrOG5qYQmo2mRqMGWs0+8gOnLTWd0kF3iCyNXng='
WHERE
key_id = '3896942de86f9cc30fc5e1bc34ba78b456e5b6d5b57ab768be90f28d96664727'
AND (
token = 'VTtDLrOG5qYQmo2mRqMGWs0+8gOnLTWd0kF3iCyNXng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)