UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XmmzYApUZ0bVDr1jWQi0RrfvM8skuH+Rh+3Fr5i+bh4='
WHERE
key_id = '28502b348e446c9976ac98fab5ed980fe79d78f61773ecc4797968834be2b346'
AND (
token = 'XmmzYApUZ0bVDr1jWQi0RrfvM8skuH+Rh+3Fr5i+bh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)