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