UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KvWgHz5vhq28Neq8fdadZfganc6DizvRoPo83P4xwy4='
WHERE
key_id = 'de8a69664e2b7c07f5613900293d6c96920b5335a0ff62415674186c0b336ba0'
AND (
token = 'KvWgHz5vhq28Neq8fdadZfganc6DizvRoPo83P4xwy4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)