SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'd16a6edfed85cb53be4973a6d11194e0d88f2cbf46e2e51699e25a569f85f9b6' 
  AND token = 'nMX8OUPHkpP4jUBihNnlB3hyiuac69L/gybecl6SUbg=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00030

JSON explain

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