UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/tDKZTukWFCo+azxVnFK/ZjUz3OS8+spwjOjvHZ8wUY='
WHERE
key_id = '7b110c7afa5d6261827714685b413bef7d1b668a35ba501767709c5b71b17913'
AND (
token = '/tDKZTukWFCo+azxVnFK/ZjUz3OS8+spwjOjvHZ8wUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)