UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QXJGv9V0EWH79hE+vuCk2VcLUgWHR42JelbU+tSFqkY='
WHERE
key_id = 'ea67d9d76768037da7db1383f7c8513dec171c9970eb69b57b0380cce47cf339'
AND (
token = 'QXJGv9V0EWH79hE+vuCk2VcLUgWHR42JelbU+tSFqkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)