UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N9Yrs9NcxgI6eW0HpyFGL+QtFL6ac+rSXLRIjpMt9HM='
WHERE
key_id = '1ed446d308a44db5bc2fa0a64f2fe0711e2355bbd98dd439cd334705c7554bc1'
AND (
token = 'N9Yrs9NcxgI6eW0HpyFGL+QtFL6ac+rSXLRIjpMt9HM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)