UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HpAPMJSgEbHF5ZJTyjMi43kpwR0fOUHKCth3x8saZDQ='
WHERE
key_id = '1c696e5b1c2b590e57fa3e3b3544940fa4e69ec540556651220a6e86d30fd855'
AND (
token = 'HpAPMJSgEbHF5ZJTyjMi43kpwR0fOUHKCth3x8saZDQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)