SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '2e7243bd6f0d0defe2d41f941e5e9b1ce3bd101f33175b5998559a55036c75f4' 
  AND token = 'NP/2Xu9+UhXrgv4v8UbEEcH+QRvSaaPVfPV9QGmj4us=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00027

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}