UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qgMJx3Ecc0gYETDtk3U1FSObnqvC5SR4p8ZmoRb3t5w='
WHERE
key_id = '9695ee6ea945f20702625df64dcdb9f0c8a862eb58a40e1b2444c3de1a2698a0'
AND (
token = 'qgMJx3Ecc0gYETDtk3U1FSObnqvC5SR4p8ZmoRb3t5w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)