UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XQHBZLpfcl2TqE7PZ3FxubtzKHz3oQ2OupGawyEjkpQ='
WHERE
key_id = '46ddfdb221aa22129c7aaea037fdb920fa7ad73640ef34cd89674d6e6bc7174a'
AND (
token = 'XQHBZLpfcl2TqE7PZ3FxubtzKHz3oQ2OupGawyEjkpQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)