UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f4qM7C0YReVLrgNlDW9RkKB6H2CSFKo6QNJVJChvfPo='
WHERE
key_id = 'd7e9fac9b5bfbb2c742701b1f35624659880c24faebfdea0be97b9a715471d2f'
AND (
token = 'f4qM7C0YReVLrgNlDW9RkKB6H2CSFKo6QNJVJChvfPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)