UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PFCCgC7qlaQtSnl94frZ8DpUun9dwoFyBCv8ANHRS5s='
WHERE
key_id = '2981094c1b4c22bd31f29bd2b18e167e46cca5a3bc49cab36c4c0db0c22eacf9'
AND (
token = 'PFCCgC7qlaQtSnl94frZ8DpUun9dwoFyBCv8ANHRS5s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)