UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Z1rJhBZKfesKpOHv+vBLsrefzTAHdpETy1iUf5Jy10='
WHERE
key_id = '9c54ce0a5175970ccfc69c0ddc89a4e3284c00495cd64d6d5c563591d592de31'
AND (
token = '7Z1rJhBZKfesKpOHv+vBLsrefzTAHdpETy1iUf5Jy10='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)