UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ow8RvyXTw7lDBJqG9A2BjDYRUwUF22dXQrn1vIUnBc4='
WHERE
key_id = '0c597117e1f905eb4d5906d4b575b2d6691ce35826d0c3c9eb6aa96f9e4bbc38'
AND (
token = 'Ow8RvyXTw7lDBJqG9A2BjDYRUwUF22dXQrn1vIUnBc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)