SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'edf42a3642b07d9a9044d42164402194bd5109c2abd7889a1a15fc6586a48cec' 
  AND token = '7CyHLJ3ZG0IgMzlLyySN1z8ZG6wN+mrX1id7L0YyQxs=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00039

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}