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