UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+DNfP8KGzbq5a8cGokJU+y7hOi+VVjGEfhzV9QeTnAg=' 
WHERE 
  key_id = 'f82d2c8503f97c2bfe548ccc6b2060fd7f00b2f54fbb947e1c9ebd2453110266' 
  AND (
    token = '+DNfP8KGzbq5a8cGokJU+y7hOi+VVjGEfhzV9QeTnAg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043