SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1011082da4c33b917afe27c71980915024f5151ee7f60d892f515a7b7268fdbb' 
  AND token = 'y7ogzR4Vz5HjSRLHXgBVW8QgIe0G9zRZO4zGkx3nWkw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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