SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '25a3730df652209898ab0b78813ef929677d7716d2b118e06f8edeafb2d3750f' 
  AND token = '8IbwvYqEA6Iny3uVAMB2Czcz2A1xRkFOqk9IL2O3+os=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00040

JSON explain

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