UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+rZpNIA3Oz4C0taLtVqPphKQ6WHJ3inAi3UEaQWrh4M='
WHERE
key_id = '77c0c1b65c49fdca3cffc965a06cca2c6acab343855410f0bdc3f8edac025679'
AND (
token = '+rZpNIA3Oz4C0taLtVqPphKQ6WHJ3inAi3UEaQWrh4M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)