UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4atIaSLmPYbhg8c6O4P7HZGITBnBYmi7qwMH3qJGavo='
WHERE
key_id = '36171b0e8b4567848002683869ca6bc48174032a8bf169e0d72053bfce3af549'
AND (
token = '4atIaSLmPYbhg8c6O4P7HZGITBnBYmi7qwMH3qJGavo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)