UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v0wPl6eT64TZ/odERtl9G1h5JiVsbgC7xE+nmtgOf/E='
WHERE
key_id = '3987733bdcae1e5e693483e8ee2647b5a399f1ae6e4781c60c58c9facaebc18c'
AND (
token = 'v0wPl6eT64TZ/odERtl9G1h5JiVsbgC7xE+nmtgOf/E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)