UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0mYF8S1yTj7QQJlpU5QggmEyufuLgOASlNSWJSlW9eA='
WHERE
key_id = '7f9534fa10d29cea94c88f257f03a3b383fe9a6828a555b3065400babc7fd3db'
AND (
token = '0mYF8S1yTj7QQJlpU5QggmEyufuLgOASlNSWJSlW9eA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)