SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '3e7b10e7bdcc0fee67c1fb182d15f7c0c5952c69a5c5456a9a18cc60f269507b' 
  AND token = 'jyZ4LnbZ2DjPXkvJ+LB8HfE/MsVyDsaMhIOLoKdC7Zo=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00021

JSON explain

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