UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'y+Qq8gC5uGKOC/8gvbh5bhh16kCLk0SmxkqVt9i7ziQ=' 
WHERE 
  key_id = '808ee7bc5291c12cc270c362947ece2e473c0d0a192a076d4333e0f38116ef8f' 
  AND (
    token = 'y+Qq8gC5uGKOC/8gvbh5bhh16kCLk0SmxkqVt9i7ziQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023