SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '0a40789be4ff40a741da9fdf48cc9d5a15ea4c53ccf4d165e8f53b3481ca09ae' 
  AND token = 'X5I4TEYNGhp83x94k6Rgdw5IgSN8USudroo8j3MlTCg=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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