UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'a68UNQb93K6rHBnJSk80FgAeB2/IVHCOIkGtQ+b+T5w=' 
WHERE 
  key_id = 'd20e2615c11cbf18d9ee6603f6e486289c446d7217f35e6d4e6c9566d8a9af87' 
  AND (
    token = 'a68UNQb93K6rHBnJSk80FgAeB2/IVHCOIkGtQ+b+T5w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034