UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'krY0dGqoILUL/bU/oTqjRTCE7GREBLNfcjTyPrGmVkw='
WHERE
key_id = 'c31b41465f1646d612bb78f91aafa34ba8517124a65b825ac5296a6f44e96fee'
AND (
token = 'krY0dGqoILUL/bU/oTqjRTCE7GREBLNfcjTyPrGmVkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)